-- =============================================
-- Author:		Rodrigo Martins
-- Create date: 15/11/2013
-- Description:	Inserir Alimentacao
-- =============================================
CREATE PROCEDURE ai_sp_inserirAlimentacao
	@id int output,		
	@data smallDateTime,
	@horario float,
	@descricao varchar(255),
	@qtd_caloria float
	
AS
BEGIN
	INSERT INTO [Alimentacao]
       ([data]
	   ,[horario] 
	   ,[descricao] 
	   ,[qtd_caloria]	   
	   )

     VALUES
       (
	    @data
	   ,@horario
	   ,@descricao
	   ,@qtd_caloria        
       )
   select @id = @@IDENTITY

END
GO
